Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8
9 <?php
10 require_once('session1.php');
11 ?>
12 <?php
13 $id = $_GET['id'];
14 $select = "SELECT * FROM
15 course as t, departments as r
16 WHERE
17 t.course_id = $id AND
18 r.department_id = t.department_id";
19 $result = mysqli_fetch_array(mysqli_query($conn,$select));
20 $qry=mysqli_query($conn,$select);
21 if($qry)
22 {
23 foreach(mysqli_fetch_array($qry) as $k => $rec){
24 if(!is_numeric($k))
25 $$k = $rec;
26 }
27 }
28
29
30 ?>
31 <!-- JAVASCRIPT FILES PLACED AT THE BOTTOM TO REDUCE THE LOADING TIME -->
32 <!-- CORE JQUERY -->
33 <script src="js/plugins/jquery-1.10.2.js"></script>
34 <!-- BOOTSTRAP SCRIPTS -->
35 <script src="js/plugins/bootstrap.js"></script>
36
37
38 <!DOCTYPE html>
39 <html>
40
41 <head>
42 <meta charset="utf-8">
43 <meta name="viewport" content="width=device-width, initial-scale=1.0">
44 <title>school management system</title>
45 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
46 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
47 <link href="assets/css/loader.css" rel="stylesheet" />
48 <script src="assets/js/canvasjs.min.js"></script>
49 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
50 <script src="assets/js/jquery-3.2.1.js"></script>
51
52 <style type="text/css">
53 h4{
54 color:red;
55 }
56 </style>
57 </head>
58
59 <body >
60 <!--end of heading section-->
61 <ul class="nav navbar-right top-nav">
62 <div class="dropdown">
63 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
64 <?php
65 //Check to see if the user is logged in.if not redirect user to the loging page.
66
67 if(isset($_SESSION['fname']))
68 {
69 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
70 }else{
71 echo "<script type='text/javascript'>
72 alert( 'You must Log in to use the system');
73 </script>";
74 echo "<script>
75 window.location = 'index.php'
76 </script>";
77 }
78 ?>
79 <span class="caret"></span></button>
80 <ul class="dropdown-menu">
81 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
82 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
83 <li class="divider"></li>
84 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
85 </ul>
86 </div>
87 </ul>
88 <!--************************************************-->
89 <div style="
90 font-family:Nyala, Arial;
91 text-align: left;
92 background-color: #526F35;
93 padding: 20px;
94 color:white;
95 width: 100%;
96 height: 150px;">
97 <!--This codes to load the image loader-->
98 <div id="loading">
99 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
100 </div>
101 <!--this is the heading section-->
102 <h2>
103 <?php
104 $query=mysqli_query($conn,"select * from companyinfo");
105 $num_rows=mysqli_num_rows($query);
106 while($row=mysqli_fetch_array($query))
107 {
108 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
109 $cname = $row['cname'];
110 $cemail = $row['cemail'];
111 $ccontact = $row['ccontact'];
112 $clocation = $row['clocation'];
113 }?>
114 <?php
115 echo $cname;
116 ?>
117
118 <div style="float:right; font-size:20px;text-align:right;">
119
120 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
121 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
122 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
123
124 </div>
125 </h2>
126 </div>
127 <!--end of heading section-->
128
129 <div>
130 <ul class="nav nav-tabs">
131 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
132 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
133 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
134 <li class="active"><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
135 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
136 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
137 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
138 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
139 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
140 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
141
142 </ul>
143 <div class="tab-content">
144 <div class="tab-pane active" role="tabpanel" id="tab-1">
145
146 <p>
147 <div class="table-responsive" >
148 <!--**************************************************************************************************************************-->
149 <div class="container" style="width:100%">
150
151 <ul class="nav nav-tabs">
152 <li ><a href="course.php">New Course<img src="assets/img/new.png"> </a></li>
153
154 <li class="active"><a href="editcourse.php">Edit course <img src="assets/img/update2.png"> </a></li>
155 <li><a href="csvtesting.php">Import/Export CSV<img src="assets/img/export.png"></a></li>
156 <li ><a href="deletecourse.PHP">Delete <img src="assets/img/delete2.png"></a></li>
157 <li><a href="#">Manage Course </a></li>
158
159 </ul>
160 <br>
161
162 </div>
163
164
165 <!--*************************************************************************************************************************-->
166 <div class="container-fluid">
167 <div class="row">
168 <div class="col-lg-6 col-lg-offset-3">
169 <div class="panel panel-primary">
170 <div class="panel-heading">Edit Course</div>
171
172 <!-- /.panel-heading -->
173 <div class="panel-body">
174 <div class="table">
175
176 <form action="updatecourse.php" method="POST" enctype="multipart/form-data">
177 <div style=" position:relative">
178 <h4>Course Details</h4>
179
180 <label>Course ID:</label>
181 <input type="text" name="course_id" value="<?php echo $id; ?>" class="form-control">
182
183 <label>Course name</label>
184 <input type="text" name="coursename" value="<?php echo $coursename ;?>" class="form-control">
185
186 <label>Exam Body</label>
187 <input type="text" name="exambody" value="<?php echo $exambody?>" class="form-control">
188
189 <label>Duration</label>
190 <input type="text" name="duration" value="<?php echo $duration?>" class="form-control">
191
192 <label>Fee Payable</label>
193 <input type="text" name="feepayable" value="<?php echo $feepayable?>" class="form-control">
194
195 <label>Department ID</label>
196 <select id="department_id" name="department_id" value="<?php echo $department_id?>" class="form-control">
197 <option></option>
198 <?php
199 $query=mysqli_query($conn,"select * from departments");
200 while($row=mysqli_fetch_array($query))
201 {
202 if($result['department_id'] == $row['department_id']){
203 $sel = "selected";
204 }else{
205 $sel = "";
206 }
207 ?>
208 <option value="<?php echo $row['department_id'];?>" <?=$sel?> > <?php echo $row['departmentname'];?> </option>
209 <?php
210 } ?>
211 </select>
212
213 <input type="submit" name="register" value="Update" class="btn btn-success">
214 <a button type='button' class="btn btn-primary" href="course.php">Back</a> <br><br>
215 </div>
216 </form>
217 </div>
218 </div>
219 </div>
220 </div>
221 </div>
222
223 <!--*************************************PHP CODES TO SAVE THE DATA************************************************-->
224
225
226 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
227 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
228 </div>
229 <script src="assets/js/jquery.min.js"></script>
230 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
231 <script src="assets/js/affix.js"></script>
232 <script src="assets/js/alert.js"></script>
233 <script src="assets/js/alert1.js"></script>
234 <script src="assets/js/bootstrap.js"></script>
235 <script src="assets/js/bootstrap.min.js"></script>
236 <script src="assets/js/bootstrap-datepicker.js"></script>
237 <script src="assets/js/bootstrap-wysihtml5.js"></script>
238 <script src="assets/js/button.js"></script>
239 <script src="assets/js/carousel.js"></script>
240 <script src="assets/js/chosen.jquery.min.js"></script>
241 <script src="assets/js/ckeditor.js"></script>
242 <script src="assets/js/collapse.js"></script>
243 <script src="assets/js/color.js"></script>
244 <script src="assets/js/dropdown.js"></script>
245 <script src="assets/js/DT_bootstrap.js"></script>
246 <script src="assets/js/dynamic.js"></script>
247 <script src="assets/js/ie-emulation-modes-warning.js"></script>
248 <script src="assets/js/jquery.dataTables.js"></script>
249 <script src="assets/js/jquery.dataTables.min.js"></script>
250 <script src="assets/js/jquery.dialog.js"></script>
251 <script src="assets/js/jquery.hoverdir.js"></script>
252 <script src="assets/js/jquery.jgrowl.js"></script>
253 <script src="assets/js/jquery.knob.js"></script>
254 <script src="assets/js/jquery.uniform.min.js"></script>
255 <script src="assets/js/jquery-1.8.3.min.js"></script>
256 <script src="assets/js/jquery-1.9.1.js"></script>
257 <script src="assets/js/jquery-1.9.1.min.js"></script>
258 <script src="assets/js/jquery-1.10.2.js"></script>
259 <script src="assets/js/jquery-1.11.0.js"></script>
260 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
261 <script src="assets/js/jquery-ui-1.10.3.js"></script>
262 <script src="assets/js/modal.js"></script>
263 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
264 <script src="assets/js/myjquery.js"></script>
265 <script src="assets/js/myjquery1.js"></script>
266 <script src="assets/js/npm.js"></script>
267 <script src="assets/js/popover.js"></script>
268 <script src="assets/js/profile.js"></script>
269 <script src="assets/js/raphael-min.js"></script>
270 <script src="assets/js/sb-admin-2.js"></script>
271 <script src="assets/js/scripts.js"></script>
272 <script src="assets/js/scrollspy.js"></script>
273 <script src="assets/js/tab.js"></script>
274 <script src="assets/js/tooltip.js"></script>
275 <script src="assets/js/transition.js"></script>
276 <script src="assets/js/wysihtml5-0.3.0.js"></script>
277 <script language="javascript" type="text/javascript">
278 $(window).load(function()
279 {
280 $('#loading').hide();
281 });
282 </script>
283 </body>
284
285 </html>